dbo.ProspectInquiry

EntityType | Independent
Logical Entity Name | ProspectInquiry
Default Table Name | SyStudentInquiry
Logical Only | NO
Owner | dbo
Definition |
Note |

dbo.ProspectInquiry Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
ProspectInquiryId |  | INTEGER | NO |
CampusId |  | INTEGER | NO |
LeadDate |  | DATETIME | NO |
OriginalAssignedAdmissionsRepId |  | INTEGER | YES |
AssignedAdmissionsRepId |  | INTEGER | YES |
ProgramGroupId |  | INTEGER | YES |
ProgramId |  | INTEGER | YES |
LeadSourceId |  | INTEGER | YES |
LeadTypeId |  | INTEGER | YES |
LastActivityDate |  | DATETIME | YES |
IsCurrentInquiry |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
AdmissionsRepTypeId |  | INTEGER | YES |
RegionId |  | INTEGER | YES |
ResponsePhoneNumber |  | CHAR(16) | YES |
ResponseTime |  | DATETIME | YES |
ResponseDate |  | DATETIME | YES |
LeadSourceId |  | INTEGER | YES |

dbo.ProspectInquiry Keys

Key Name | Key Type | Keys
SyStudentInquiry_AmRepID_N_N_IDX | Inversion Entry | AssignedAdmissionsRepId
SyStudentInquiry_AmLeadTypeID_N_N_IDX | Inversion Entry | LeadTypeId
SyStudentInquiry_AmLeadSrcID_N_N_IDX | Inversion Entry | LeadSourceId
SyStudentInquiry_AdProgramID_N_N_IDX | Inversion Entry | ProgramId
SyStudentInquiry_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId
SyStudentInquiry_SyCampusID_N_N_IDX | Inversion Entry | CampusId
SyStudentInquiry_OriginalAmRepID_N_N_IDX | Inversion Entry | OriginalAssignedAdmissionsRepId
SyStudentInquiry_AmRepTypeID_N_N_IDX | Inversion Entry | AdmissionsRepTypeId
SyStudentInquiry_AdProgramGroupID_N_N_IDX | Inversion Entry | ProgramGroupId
SyStudentInquiry_SyStudentInquiryID_U_C_IDX | PrimaryKey | ProspectInquiryId
SyStudentInquiry_SyStudentID_Current_SyStudentInquiryID_U_N_IDX | Alternate Key | IsCurrentInquiry, ProspectInquiryId

dbo.ProspectInquiry Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
Campus | Non-Identifying | Zero or One to Zero or More |  |  |  | CampusId | NO
ProgramGroup | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramGroupId | NO
Program | Non-Identifying | Zero or One to Zero or More |  |  |  | ProgramId | NO
LeadSource | Non-Identifying | Zero or One to Zero or More |  |  |  | LeadSourceId | NO
LeadType | Non-Identifying | Zero or One to Zero or More |  |  |  | LeadTypeId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | AssignedAdmissionsRepId | NO
AdmissionsRepType | Non-Identifying | Zero or One to Zero or More |  |  |  | AdmissionsRepTypeId | NO
Staff | Non-Identifying | Zero or One to Zero or More |  |  |  | OriginalAssignedAdmissionsRepId | NO
Campus | Non-Identifying | One To Zero or More |  |  |  | CampusId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO
LeadSource | Non-Identifying | Zero or One to Zero or More |  |  |  | LeadSourceId | NO
LeadType | Non-Identifying | Zero or One to Zero or More |  |  |  | LeadTypeId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
SyStudentInquiryExternalMap | Non-Identifying | One To Zero or More |  |  |  |  | NO

dbo.ProspectInquiry Check Constraints

Check Constraint Name | CheckConstraint

dbo.ProspectInquiry Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.ProspectInquiry | NO |  |  |
Physical (Microsoft SQL Server) dbo.SyStudentInquiry | NO |  |  |

dbo.ProspectInquiry Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | System

dbo.ProspectInquiry Data Movement Rules

Name | Type | Rule Text/Value